Server Type
Choose the servet type: SQL Server or Other data source
If you choose Other data source, define the required information.
Provider
Choose the unique programmatic identifier (PROGID) of the OLE DB provider corresponding to the data source.Product Name
Define the product name of the OLE DB data source to add as a linked server.Data Source
Define the name of the data source as interpreted by the OLE DB provider.Provider String
Define the OLE DB provider-specific connection string that identifies a unique data source.Location
Define the location of the database as interpreted by the OLE DB provider.Catalog
Define the catalog to be used when making a connection to the OLE DB provider.